Storage Layout and I/O Performance Tuning for IBM® Red Brick® Data Warehouse

Although Red Brick performance depends primarily on the logical database design, the placement and allocation of data files in the disk subsystem is another significant performance factor. There are many choices in the configuration and design of the physical database layout. This article reviews best practices propagated by storage and database vendors and presents measurements that compare storage layout alternatives for Red Brick. This leads to specific I/O configuration and tuning guidelines for IBM Red Brick Data Warehouse. This article assumes that the reader has basic knowledge of Red Brick Data Warehouse. Notices and trademarks The furnishing of this document does not imply giving license to any IBM patents. References in this document to IBM products, Programs, or Services do not imply that IBM intends to make these available in all countries in which IBM operates. The information contained in this publication does not include any product warranties, and any statements provided in this document should not be interpreted as such. The following terms are trademarks or registered trademarks of International Business Machines Corporation in the United States, other countries, or both: AIX Enterprise Storage Server DB2 DB2 Universal Database IBM Informix Red Brick Other products or service names may be trademarks or regis tered trademarks of their respective owners. © Copyright International Business Machines Corporation 2002. All rights reserved. Table of